From e70280f670e24c5dca32cff6cd7c6ba8c27917b0 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 27 Oct 2025 17:28:53 +0000 Subject: [PATCH] Remove trailing spaces from follow_arrival.fa_fol_b_focal_animid Fixes problem #56 --- conversion/clean.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index 2560b9d..8e3664d 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -237,6 +237,12 @@ UPDATE follow -- follow_arrival -- +-- +-- Remove trailing spaces from focal Problem #56 +UPDATE follow_arrival + SET fa_fol_b_focal_animid = RTRIM(fa_fol_b_focal_animid) + WHERE follow_arrival.fa_fol_b_focal_animid <> RTRIM(fa_fol_b_focal_animid); + -- -- Update the follow_arrival.fa_type_of_cycle -- -- 2.34.1